Exact Financials

GL_BAL

GL_BAL (company,seqnr, total, key_1, [ key_2, key_3, key_4, key_5, key_6, key_7, key_8, key_9, key_10 ] )

By using this function, you can include the balance of a user defined total on the g/l transactions in the worksheet.

SeqNr determines which cumultative definition of table g/l transactions (900331) should be used. Total determines which total field (value 1 through 10) should be returned.

Example

GL_BAL(621,1,1,"2005", "12", "4000", "ADMI", "HEREN")

As a result of the above function, the first total defined for g/l transactions (in which key value 1 was defined as year, key value 2 as period, key value 3 as g/l account, key value 4 as cost center and key value 5 as cost unit) is shown.

! Integers are stored without leading zeroes in stcumdat. If one of the key fields is period, consider that the values 10, 11 and 12 are alphabetically sorted between 1 and 2. If you want to view the results of period 0 thru 11 you cannot use GL_BAL( 621,1,1,"0:11" ) but need to split this up into two parts:

= GL_BAL( 621,1,1, "_" ) + GL_BAL( 621,1,1, "10:11" )

The above uses the wildcard functionality for the first part ( the underscore _ matches any single character, ie 0 thru 9 ) and a range for the second part ( the colon : allows range handling ).

See also:

[Alphabetical overview of parameters]

Excel Add-in Manual > Contents > Functions > GL_BAL